-- -----------------------------------------------------
-- ATTENTION: la syntaxe des tables et des colonnes est 
-- à adpater selon celle utilisée par les étudiants
-- -----------------------------------------------------

START TRANSACTION;
USE `db_portique`;

-- -----------------------------------------------------
-- Table `db_portique`.`nodes`
-- -----------------------------------------------------
INSERT INTO `db_portique`.`nodes` (`id_nodes`, `x`, `y`, `z`) VALUES ('N1', '0', '0', '0');
INSERT INTO `db_portique`.`nodes` (`id_nodes`, `x`, `y`, `z`) VALUES ('N2', '0', '0', '10');
INSERT INTO `db_portique`.`nodes` (`id_nodes`, `x`, `y`, `z`) VALUES ('N3', '15', '5', '10');
INSERT INTO `db_portique`.`nodes` (`id_nodes`, `x`, `y`, `z`) VALUES ('N4', '15', '5', '2');
-- -----------------------------------------------------
-- Table `db_portique`.`material`
-- -----------------------------------------------------
INSERT INTO `db_portique`.`material` (`id_material`, `material_name`, `material_type`) VALUES ('M1', 'concrete', 'C20/25');
INSERT INTO `db_portique`.`material` (`id_material`, `material_name`, `material_type`) VALUES ('M2', 'concrete', 'C30/37');
INSERT INTO `db_portique`.`material` (`id_material`, `material_name`, `material_type`) VALUES ('M3', 'wood', 'GL24h');

-- -----------------------------------------------------
-- Table `db_portique `.`section`
-- -----------------------------------------------------
INSERT INTO `db_portique`.`section` (`id_section`, `section_name`, `section_type`) VALUES ('S1', 'R30x40', '30x40');
INSERT INTO `db_portique`.`section` (`id_section`, `section_name`, `section_type`)  VALUES ('S2', 'R40x50', '40x50');
INSERT INTO `db_portique`.`section` (`id_section`, `section_name`, `section_type`)  VALUES ('S3', 'C60' ,'60');

-- -----------------------------------------------------
-- Table `db_portique `.`concrete`
-- -----------------------------------------------------
INSERT INTO `db_portique`.`concrete` (`id_concrete`, `compressive_strength`, `shear_strength`, `compression_strain`, `breaking_strain`, `compressive_strength_coefficient`) VALUES ('C12/15', '8', '0.7', '0.002', '0.003', '3.8');
INSERT INTO `db_portique`.`concrete` (`id_concrete`, `compressive_strength`, `shear_strength`, `compression_strain`, `breaking_strain`, `compressive_strength_coefficient`) VALUES ('C16/20', '10.5', '0.8', '0.002', '0.003', '3.4');
INSERT INTO `db_portique`.`concrete` (`id_concrete`, `compressive_strength`, `shear_strength`, `compression_strain`, `breaking_strain`, `compressive_strength_coefficient`) VALUES ('C20/25', '13.5', '0.9', '0.002', '0.003', '3.2');
INSERT INTO `db_portique`.`concrete` (`id_concrete`, `compressive_strength`, `shear_strength`, `compression_strain`, `breaking_strain`, `compressive_strength_coefficient`) VALUES ('C25/30', '16.5', '1', '0.002', '0.003', '2.9');
INSERT INTO `db_portique`.`concrete` (`id_concrete`, `compressive_strength`, `shear_strength`, `compression_strain`, `breaking_strain`, `compressive_strength_coefficient`) VALUES ('C30/37', '20', '1.1', '0.002', '0.003', '2.7');
INSERT INTO `db_portique`.`concrete` (`id_concrete`, `compressive_strength`, `shear_strength`, `compression_strain`, `breaking_strain`, `compressive_strength_coefficient`) VALUES ('C35/45', '22', '1.2', '0.002', '0.003', '2.6');
INSERT INTO `db_portique`.`concrete` (`id_concrete`, `compressive_strength`, `shear_strength`, `compression_strain`, `breaking_strain`, `compressive_strength_coefficient`) VALUES ('C40/50', '24', '1.25', '0.002', '0.003', '2.4');
INSERT INTO `db_portique`.`concrete` (`id_concrete`, `compressive_strength`, `shear_strength`, `compression_strain`, `breaking_strain`, `compressive_strength_coefficient`) VALUES ('C45/55', '26', '1.35', '0.002', '0.003', '2.3');
INSERT INTO `db_portique`.`concrete` (`id_concrete`, `compressive_strength`, `shear_strength`, `compression_strain`, `breaking_strain`, `compressive_strength_coefficient`) VALUES ('C50/60', '28', '1.4', '0.002', '0.003', '2.2');

-- -----------------------------------------------------
-- Table `db_portique `.`rectangle`
-- -----------------------------------------------------
INSERT INTO `db_portique`.`rectangle` (`id_rectangle`, `length`, `width`) VALUES ('30x40', '40', '30');
INSERT INTO `db_portique`.`rectangle` (`id_rectangle`, `length`, `width`) VALUES ('40x50', '50', '40');
-- -----------------------------------------------------
-- Table `db_portique `.`circular`
-- -----------------------------------------------------
INSERT INTO `db_portique`.`circular` (`id_circular`, `diameter`) VALUES ('60', '60');

-- -----------------------------------------------------
-- Table `db_portique `.`wood`
-- -----------------------------------------------------
INSERT INTO `db_portique`.`wood` (`id_wood`, `bending_around_y`, `bending_around_z`, `parallel_traction`, `parallel_compression`, `parallel_young_modulus`, `perpendicular_traction`, `perpendicular_compression`, `perpendicular_young_modulus`, `mean_poisson_ratio`, `tangential_stress`, `density`) VALUES ('GL24h', '24', '28.8', '16.5', '24', '11600', '0.5', '2.7', '390', '720', '2.5', '380');
INSERT INTO `db_portique`.`wood` (`id_wood`, `bending_around_y`, `bending_around_z`, `parallel_traction`, `parallel_compression`, `parallel_young_modulus`, `perpendicular_traction`, `perpendicular_compression`, `perpendicular_young_modulus`, `mean_poisson_ratio`, `tangential_stress`, `density`) VALUES ('GL24c', '24', '24', '14', '21', '11600', '0.5', '2.4', '320', '590', '2.5', '350'); 

-- -----------------------------------------------------
-- Table `db_portique `.`frame`
-- -----------------------------------------------------
INSERT INTO `db_portique`.`frame` (`id_frame`, `frame_name`, `start_node_id`, `end_node_id`, `section_id_section`, `material_id_material`) VALUES ('F1', 'Column', 'N1', 'N2', 'S1', 'M1');
INSERT INTO `db_portique`.`frame` (`id_frame`, `frame_name`, `start_node_id`, `end_node_id`, `section_id_section`, `material_id_material`) VALUES ('F2', 'Beam', 'N2', 'N3', 'S2', 'M3');
INSERT INTO `db_portique`.`frame` (`id_frame`, `frame_name`, `start_node_id`, `end_node_id`, `section_id_section`, `material_id_material`) VALUES ('F3', 'Column', 'N3', 'N4', 'S3', 'M2');